Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
SupplierItemID (FK)(PK) | The code assigned by the supplier to uniquely identify the ITEM | ID_ITM_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
SupplierItemCostPerUnitTypeCode (PK) | Defines the unit type the owned attribute costs are assigned to for this item. Valid unit types include: SALE UNIT, PACK UNIT and SHIP UNIT. A single SUPPLIER ITEM may in effect have 1 to three SUPPLIER ITEM BASE COST entities associated with it. | TY_UN_CST | Code2 | char(2) | |
PerUnitAmount | The published cost, excluding any allowances for discounts, for the SUPPLIER ITEM. | CP_UN_BS | MoneyShortCost | decimal(16,5) | |
NetCostPerUnitAmount | The published unit cost including allowances and charges for the item. | CP_UN_NT | MoneyShortCost | decimal(16,5) | |